/*
 Navicat Premium Data Transfer

 Source Server         : 甄宝线上
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : rm-bp15m1koq9466l58zko.mysql.rds.aliyuncs.com:3306
 Source Schema         : mall

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 19/09/2020 15:05:07
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_menus`;
CREATE TABLE `sys_menus` (
  `item_code` int(11) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(255) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `item_child_count` bigint(20) DEFAULT NULL,
  `item_depth` int(11) DEFAULT NULL,
  `item_enable` bit(1) DEFAULT NULL,
  `item_function` bit(1) DEFAULT NULL,
  `item_icon_cls` varchar(255) DEFAULT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `item_parent_code` int(11) DEFAULT NULL,
  `item_path` varchar(255) DEFAULT NULL,
  `item_remark` varchar(255) DEFAULT NULL,
  `item_sort` int(11) DEFAULT NULL,
  PRIMARY KEY (`item_code`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_menus
-- ----------------------------
BEGIN;
INSERT INTO `sys_menus` VALUES (1, '2020-06-26 19:23:43', NULL, '2020-09-16 09:31:34', 7, NULL, b'1', b'0', 'cogs', '系统配置', 0, '/none', NULL, 99);
INSERT INTO `sys_menus` VALUES (2, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 5, NULL, b'1', b'0', 'bars', '菜单管理', 1, '/sys/menus', NULL, 2);
INSERT INTO `sys_menus` VALUES (3, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '添加和编辑', 2, '/sys/ajax/save', NULL, 1);
INSERT INTO `sys_menus` VALUES (4, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '详情', 2, '/sys/ajax/details', NULL, 1);
INSERT INTO `sys_menus` VALUES (5, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '列表', 2, '/sys/ajax/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (6, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '删除', 2, '/sys/ajax/delete', NULL, 1);
INSERT INTO `sys_menus` VALUES (7, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '设置状态', 2, '/sys/ajax/activate', NULL, 1);
INSERT INTO `sys_menus` VALUES (8, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:44', 6, NULL, b'1', b'0', 'user', '角色管理', 1, '/sys/roles', NULL, 3);
INSERT INTO `sys_menus` VALUES (9, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '列表', 8, '/sys/ajax/rolelist', NULL, 1);
INSERT INTO `sys_menus` VALUES (10, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '权限列表', 8, '/sys/ajax/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (11, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '设置状态', 8, '/sys/ajax/setenable', NULL, 1);
INSERT INTO `sys_menus` VALUES (12, '2020-06-26 19:23:43', NULL, '2020-06-26 19:23:43', 0, NULL, b'1', b'1', '', '删除', 8, '/sys/ajax/deleterole', NULL, 1);
INSERT INTO `sys_menus` VALUES (13, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'1', '', '设置权限', 8, '/sys/ajax/setpower', NULL, 1);
INSERT INTO `sys_menus` VALUES (14, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'1', '', '添加和编辑', 8, '/sys/ajax/editrole', NULL, 1);
INSERT INTO `sys_menus` VALUES (15, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 3, NULL, b'1', b'0', 'users', '账户管理', 1, '/sys/manager', NULL, 4);
INSERT INTO `sys_menus` VALUES (16, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'1', '', '添加和编辑', 15, '/sys/ajax/editmanager', NULL, 1);
INSERT INTO `sys_menus` VALUES (17, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'1', '', '列表', 15, '/sys/ajax/managerlist', NULL, 1);
INSERT INTO `sys_menus` VALUES (18, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'1', '', '设置状态', 15, '/sys/ajax/setuserenable', NULL, 1);
INSERT INTO `sys_menus` VALUES (19, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 1, NULL, b'1', b'0', 'list', '全局配置', 1, '/config/getConfig', NULL, 0);
INSERT INTO `sys_menus` VALUES (20, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'1', '', '编辑', 19, '/config/ajax/save', NULL, 1);
INSERT INTO `sys_menus` VALUES (21, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '广告列表', 1, '/banner/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (22, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'0', b'0', 'edit', '添加广告', 1, '/banner/edit', NULL, 1);
INSERT INTO `sys_menus` VALUES (23, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 3, NULL, b'1', b'0', 'file-text-o', '产品管理', 0, 'none', NULL, 49);
INSERT INTO `sys_menus` VALUES (24, '2020-06-26 19:23:44', NULL, '2020-07-22 14:05:43', 0, NULL, b'1', b'0', 'list', '店铺商品列表', 23, '/product/normalList?saleType=0', NULL, 1);
INSERT INTO `sys_menus` VALUES (25, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'pencil-square-o', '类目管理', 23, '/category/list', NULL, 3);
INSERT INTO `sys_menus` VALUES (26, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '专区管理', 23, '/specialArea/list', NULL, 3);
INSERT INTO `sys_menus` VALUES (27, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 3, NULL, b'1', b'0', 'users', '用户管理', 0, 'none', NULL, 48);
INSERT INTO `sys_menus` VALUES (28, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '粉丝列表', 27, '/user/list?type=0', NULL, 3);
INSERT INTO `sys_menus` VALUES (29, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '会员列表', 27, '/user/list?type=1', NULL, 3);
INSERT INTO `sys_menus` VALUES (30, '2020-06-26 19:23:44', NULL, '2020-09-09 09:13:36', 3, NULL, b'1', b'0', 'list', '提现管理', 27, 'none', NULL, 3);
INSERT INTO `sys_menus` VALUES (31, '2020-06-26 19:23:44', NULL, '2020-09-09 09:13:47', 0, NULL, b'1', b'0', 'list', '余额提现列表', 30, '/withdraw/list?type=0', NULL, 1);
INSERT INTO `sys_menus` VALUES (32, '2020-06-26 19:23:44', NULL, '2020-07-07 16:26:12', 0, NULL, b'1', b'0', 'list', '提现配置', 30, '/withdraw/config', NULL, 3);
INSERT INTO `sys_menus` VALUES (34, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 4, NULL, b'1', b'0', 'list', '订单管理', 0, 'none', NULL, 47);
INSERT INTO `sys_menus` VALUES (35, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '销售订单', 34, '/order/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (36, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '业务订单', 34, '/order/biz/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (37, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '售后申请', 34, '/order/afterSale/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (38, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '发货单', 34, '/order/deliver/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (39, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 2, NULL, b'1', b'0', 'folder', '商户管理', 0, 'none', NULL, 48);
INSERT INTO `sys_menus` VALUES (40, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '商户列表', 39, '/merchant/list?dataType=1', NULL, 1);
INSERT INTO `sys_menus` VALUES (41, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'list', '审核列表', 39, '/merchant/list?dataType=0', NULL, 2);
INSERT INTO `sys_menus` VALUES (42, '2020-06-26 19:23:44', NULL, '2020-06-26 19:23:44', 0, NULL, b'1', b'0', 'desktop', '桌面', 0, '/desktop', NULL, 0);
INSERT INTO `sys_menus` VALUES (43, '2020-06-29 18:16:15', NULL, '2020-09-07 11:49:22', 2, NULL, b'1', b'0', 'folder', '直播管理', 0, '/none', NULL, 8);
INSERT INTO `sys_menus` VALUES (45, '2020-07-31 18:43:06', NULL, '2020-07-31 18:43:06', NULL, NULL, b'1', b'0', 'list', '社区管理', 0, '/community/list', NULL, 50);
INSERT INTO `sys_menus` VALUES (46, '2020-08-11 13:17:03', NULL, '2020-08-22 09:39:12', 3, NULL, b'1', b'0', 'folder', '广告位管理', 0, '/none', NULL, 51);
INSERT INTO `sys_menus` VALUES (47, '2020-08-11 13:17:42', NULL, '2020-08-11 13:17:42', NULL, NULL, b'1', b'0', 'edit', '首页广告模块', 46, '/module/home', NULL, 1);
INSERT INTO `sys_menus` VALUES (48, '2020-08-11 13:18:00', NULL, '2020-08-11 13:18:00', NULL, NULL, b'1', b'0', 'edit', '首页专区配置', 46, '/module/home/icon', NULL, 2);
INSERT INTO `sys_menus` VALUES (49, '2020-08-19 16:24:09', NULL, '2020-09-07 20:08:53', 7, NULL, b'1', b'0', 'folder', '直播间回复', 0, '/none', NULL, 99);
INSERT INTO `sys_menus` VALUES (50, '2020-08-19 16:25:09', NULL, '2020-08-19 16:25:09', NULL, NULL, b'1', b'0', 'edit', '翠庐珠宝直播', 49, '/live/sendGeneralMessage?roomId=38', NULL, 1);
INSERT INTO `sys_menus` VALUES (51, '2020-08-19 16:26:51', NULL, '2020-08-19 16:26:51', NULL, NULL, b'1', b'0', 'edit', '道一珠宝直播', 49, '/live/sendGeneralMessage?roomId=36', NULL, 2);
INSERT INTO `sys_menus` VALUES (52, '2020-08-19 16:27:40', NULL, '2020-08-19 16:27:40', NULL, NULL, b'1', b'0', 'edit', '珏创珠宝', 49, '/live/sendGeneralMessage?roomId=32', NULL, 3);
INSERT INTO `sys_menus` VALUES (53, '2020-08-22 09:39:12', NULL, '2020-08-22 09:39:12', NULL, NULL, b'1', b'0', 'edit', '今日上新配置', 46, '/module/home/today/new', NULL, 3);
INSERT INTO `sys_menus` VALUES (55, '2020-08-27 20:04:30', NULL, '2020-08-27 20:04:50', NULL, NULL, b'1', b'0', 'edit', '协隆珠宝直播间', 49, '/live/sendGeneralMessage?roomId=37', NULL, 4);
INSERT INTO `sys_menus` VALUES (56, '2020-09-02 09:39:01', NULL, '2020-09-02 09:40:54', 2, NULL, b'1', b'0', 'folder', '积分管理', 0, '/none', NULL, 99);
INSERT INTO `sys_menus` VALUES (57, '2020-09-02 09:40:13', NULL, '2020-09-02 09:40:13', NULL, NULL, b'1', b'0', 'list', '积分商品', 56, '/integral/product/list', NULL, 1);
INSERT INTO `sys_menus` VALUES (58, '2020-09-02 09:40:54', NULL, '2020-09-02 09:40:54', NULL, NULL, b'1', b'0', 'list', '积分统计', 56, '/integral/statistics', NULL, 2);
INSERT INTO `sys_menus` VALUES (59, '2020-09-03 17:45:01', NULL, '2020-09-03 17:45:01', NULL, NULL, b'1', b'0', 'edit', '周哥盘竹根雕直播间', 49, '/live/sendGeneralMessage?roomId=2', NULL, 5);
INSERT INTO `sys_menus` VALUES (60, '2020-09-05 20:41:28', NULL, '2020-09-05 20:41:28', NULL, NULL, b'1', b'0', 'edit', '维纳斯珠宝直播首秀', 49, '/live/sendGeneralMessage?roomId=43', NULL, 5);
INSERT INTO `sys_menus` VALUES (61, '2020-09-07 11:48:00', NULL, '2020-09-07 11:52:47', NULL, NULL, b'1', b'0', 'edit', '直播间推送(请勿频繁)', 43, '/wx/template/live/template', NULL, 1);
INSERT INTO `sys_menus` VALUES (62, '2020-09-07 11:49:11', NULL, '2020-09-07 11:49:11', NULL, NULL, b'1', b'0', 'list', '直播列表', 43, '/live/list', NULL, 2);
INSERT INTO `sys_menus` VALUES (63, '2020-09-07 20:08:53', NULL, '2020-09-07 20:08:53', NULL, NULL, b'1', b'0', 'edit', '毛毛源头货直播间', 49, '/live/sendGeneralMessage?roomId=16', NULL, 6);
INSERT INTO `sys_menus` VALUES (64, '2020-09-09 09:13:36', NULL, '2020-09-09 09:13:36', NULL, NULL, b'1', b'0', 'list', '货款提现列表', 30, '/withdraw/list/type', NULL, 2);
INSERT INTO `sys_menus` VALUES (65, '2020-09-16 09:31:34', NULL, '2020-09-16 09:31:34', NULL, NULL, b'1', b'0', 'list', '关键字回复配置', 1, '/wx/keyword/list', NULL, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
